UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7RlHAHhPjWoXOGahyYc0JrWFOClrjs5UbdaMs3umfI='
WHERE
key_id = '90c123c24c6b5ace0f2e0ac0b4dd028e7b9ea89cf6bc37d8b30aedd1a24ce3aa'
AND (
token = 'z7RlHAHhPjWoXOGahyYc0JrWFOClrjs5UbdaMs3umfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)