UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+tKoQc4jtVEs8gNlICnHAlonGGS8NjlMeFzm+u6c+G8='
WHERE
key_id = '65dc39c3f36a386f18c2616f646a15545784ff5af2f59bb8db5c58d9b6497fcd'
AND (
token = '+tKoQc4jtVEs8gNlICnHAlonGGS8NjlMeFzm+u6c+G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)