UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JGfALJ1FyJiKRo5VZactszEDocHS3Y83wIWDxV+t9ys='
WHERE
key_id = 'b46897482f81f559ab5566f8ea5754eb01a99abb957403ec98f0c1ad3b0fbdcd'
AND (
token = 'JGfALJ1FyJiKRo5VZactszEDocHS3Y83wIWDxV+t9ys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)