UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ncb6svk7YkWRkTURbH2uFV7IEDG8cShuJUFp1cEwEdI='
WHERE
key_id = 'b9bf91abbc9845fd3d8399f78d18ae496cf1394f7ce321f7a2ea17084bd7a340'
AND (
token = 'Ncb6svk7YkWRkTURbH2uFV7IEDG8cShuJUFp1cEwEdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)