UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1dc+oHalb1hs/8bQquuEWJISROUcnhtVh8dHNo44JSI='
WHERE
key_id = 'b51dba515eaf108ab22664e193a2e671614a5c1aebd5eec6a1963fad08a51f12'
AND (
token = '1dc+oHalb1hs/8bQquuEWJISROUcnhtVh8dHNo44JSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)