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

Query time 0.00027