UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rFooUAQhw/kUchiqw5WfNGroHXzmtNtgWc6lhNshSBo='
WHERE
key_id = '519faafc7fae71b2289b521a4342016c698380584a043f7f5393c5d62dd9734b'
AND (
token = 'rFooUAQhw/kUchiqw5WfNGroHXzmtNtgWc6lhNshSBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)