UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zAJzD2pokFmBOER+mDA7A6H3qHbFj2veoJAnfsEjOpw=' 
WHERE 
  key_id = 'c64165b1773fe879c8e307d87273068f550acf0a06f558ccce88cb7f19a16410' 
  AND (
    token = 'zAJzD2pokFmBOER+mDA7A6H3qHbFj2veoJAnfsEjOpw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045