UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EGZK1nvclgKim9KHkSGJYBF89S6XHk1/cK6H1nkUwwg='
WHERE
key_id = '2835afe256642fb308cec0cd4517dbc697048caf1ab50e2461fe37ddfa541257'
AND (
token = 'EGZK1nvclgKim9KHkSGJYBF89S6XHk1/cK6H1nkUwwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)