UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C1af0nFSfrsoW67PmsxFpVIWYX7pPjHmjETIAZ878xw='
WHERE
key_id = '5663138ec9c7d001bc59500d257c2bbed653607532ec7b2519257bcfdc50b03a'
AND (
token = 'C1af0nFSfrsoW67PmsxFpVIWYX7pPjHmjETIAZ878xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)