UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ggVuqBjTK8DgZN1/pYdSF7kgpAkJcvCLBFZgznHtiU='
WHERE
key_id = 'd9bb123b59d5a8acc80fcd04aa8e8797d9a6e47f709f7b635fd7904d9a9709f8'
AND (
token = '+ggVuqBjTK8DgZN1/pYdSF7kgpAkJcvCLBFZgznHtiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)