UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZgGNE89Xgdm5JrDuZk7wAzHyJ6IDT7lZ8wlmuDu9cw='
WHERE
key_id = '61a8e36edd35bc844728c564ca2ddab555cda8ad5252bfd6a00c4f9137fa05df'
AND (
token = 'ZZgGNE89Xgdm5JrDuZk7wAzHyJ6IDT7lZ8wlmuDu9cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)