UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+G45GcPCH4aVZnBwRZMNt7+o1veIStsBdt2XMSHhWU='
WHERE
key_id = '3aaeb87f432330480a5721380619f7e4ee94099131a0f4407f796fa3b44e58ac'
AND (
token = 'W+G45GcPCH4aVZnBwRZMNt7+o1veIStsBdt2XMSHhWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)