UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZLNcUC9KkKXJ2s/7h6XNvRw6SBHYeV7eo4YcZDU3ocw=' 
WHERE 
  key_id = '7adb670f86129ec253b1a051cd86c24418e5caae81615ff13402cde2bf0ed1bf' 
  AND (
    token = 'ZLNcUC9KkKXJ2s/7h6XNvRw6SBHYeV7eo4YcZDU3ocw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020