UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7gL19gg9rFHa71hgOfyasQ+0TrERKScuKL8RP2GdYDM='
WHERE
key_id = 'd512192cd602559d36d409ef75dda3238c2c5e8bd26f05784f65dfa6a18f5b0c'
AND (
token = '7gL19gg9rFHa71hgOfyasQ+0TrERKScuKL8RP2GdYDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)