UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '86x0Qv1K0cc3aaJDNv0/WWhV5S84OOENYJVd7wz6zIU='
WHERE
key_id = 'fd9f7f89a2bbe65e84f85f03cee720e9af57620c3e16d74349695d70cef8735a'
AND (
token = '86x0Qv1K0cc3aaJDNv0/WWhV5S84OOENYJVd7wz6zIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)