UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VRLGvvwU/W+n4YnxreEVhrIguU13UtH+jOamWvMLUPE='
WHERE
key_id = 'a6d1fc4860514943d96324c066fe70a5ae074e69f727f4731b0b24bb80c4f30d'
AND (
token = 'VRLGvvwU/W+n4YnxreEVhrIguU13UtH+jOamWvMLUPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)