UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'deAQYxfSTj+W6JPmx53uaaxsHMuDSs5zNU6b3s/C/UI=' 
WHERE 
  key_id = 'd9c226016d350a590f543dd65abc82ad5ab350328761b8d715537ac3470203c0' 
  AND (
    token = 'deAQYxfSTj+W6JPmx53uaaxsHMuDSs5zNU6b3s/C/UI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042