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