UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YfEN7BaesDZglFucWhyL1Y2pURbZhn4fCmr5oR+gt+E='
WHERE
key_id = '186222b2dc5cf0bd2b6945eb2bb9ce4b9f62fbf8f7c1f328f08368630c809fae'
AND (
token = 'YfEN7BaesDZglFucWhyL1Y2pURbZhn4fCmr5oR+gt+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)