UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vc5gkHgUyGKltG8DOBQ+BFtyCJQD5QFehuYWsV7U3xQ='
WHERE
key_id = 'e9eb8f4943d98830683070e5c2b174e7c7ea226b14c1b9fd34107a0860408659'
AND (
token = 'vc5gkHgUyGKltG8DOBQ+BFtyCJQD5QFehuYWsV7U3xQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)