UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ip7O6p45TEa9Fw4uQEo/NBZMzR3u7gofxqHh1hNfqXo=' 
WHERE 
  key_id = 'd9385dc49d1508ef5217055287659ea9ed016bcbb09e1b218a3459e6236fe3bd' 
  AND (
    token = 'Ip7O6p45TEa9Fw4uQEo/NBZMzR3u7gofxqHh1hNfqXo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021