UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HkYprE5bs2269ZCKlWzTH3jREaG/+CYF6xxImakVXTk='
WHERE
key_id = 'e6b0c353c230f2865331a52ff331becb7b003126f2293f9fd910a7cb8f860482'
AND (
token = 'HkYprE5bs2269ZCKlWzTH3jREaG/+CYF6xxImakVXTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)