UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCXguypF2Ojmyn+5vO9lDeCQTI3BlpsZNhwPCGVIjng='
WHERE
key_id = '7f4cf72883136be6a5f7ae4870fa74b651eb094b84a28d57edd7daa770c0af5e'
AND (
token = 'VCXguypF2Ojmyn+5vO9lDeCQTI3BlpsZNhwPCGVIjng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)