UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQJkkgtHMXiTUCFFOd7HembT9HQn9q8SgOTChYiiD5c='
WHERE
key_id = 'aa10f0ad55d359c9438c828401f009a6b0c7f6d3babcc2c457179be2bce17a67'
AND (
token = 'pQJkkgtHMXiTUCFFOd7HembT9HQn9q8SgOTChYiiD5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)