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