UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQaTrhEP2MxNfIOumbYnMDbagA28tfyFExqg1iZ9gbE='
WHERE
key_id = '20147bcd6a409c2144e6dc568264733f83a9993f07e41003f7d2d9d5c790c7b3'
AND (
token = 'xQaTrhEP2MxNfIOumbYnMDbagA28tfyFExqg1iZ9gbE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)