UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YKQ64i7GnhSpUVKojY3mNg48DlTF6geEOdNlrzPwcFQ='
WHERE
key_id = 'b7fef8a2f862387f424f56ea6f4bcf5c90e3b401c59b320b146df15904137a3b'
AND (
token = 'YKQ64i7GnhSpUVKojY3mNg48DlTF6geEOdNlrzPwcFQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)