UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1dNUyVVe/WbXoKw+YkDdwLVDVm3JXlvBZ4aowHHVl18='
WHERE
key_id = '787a64f428324145e2cc28e46f8e7f669f98dc10c11036c8f3a9e80ba3e30a97'
AND (
token = '1dNUyVVe/WbXoKw+YkDdwLVDVm3JXlvBZ4aowHHVl18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)