UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '25gJLf1BBValr95S2SNv19tnSCEBIC4tpSRljLbWoGU='
WHERE
key_id = 'e0fb31c6435d71e178f3e1c4817f949d85263b85f3ab0d8bdd9fac7d03c52b1a'
AND (
token = '25gJLf1BBValr95S2SNv19tnSCEBIC4tpSRljLbWoGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)