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