UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6ciLRiRpqRT8JTLFhemkspz/z+1SckiZgRJgUQ9QvGM=' 
WHERE 
  key_id = '0bf0cc0ec81cf399d8665b626036d7b45233e41fb1bc8e90a2b57566e06e8ee8' 
  AND (
    token = '6ciLRiRpqRT8JTLFhemkspz/z+1SckiZgRJgUQ9QvGM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036