UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jopliIog0qgAHHyH/8COlesu7taGIsg5awdslh8wJJM='
WHERE
key_id = 'f8908791a11c77094bac13295f44607a2744f49d3ac5b9611d8cef791317bd60'
AND (
token = 'jopliIog0qgAHHyH/8COlesu7taGIsg5awdslh8wJJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)