UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7Sc+uv0iBm11ZyPm4zIvfBojeDWLVap1l5S/WpWf2mw=' 
WHERE 
  key_id = '2c72a1cf3845c9f6d6e69d3edd200f988be84a89ae1a4274a13914e3f3e9dec5' 
  AND (
    token = '7Sc+uv0iBm11ZyPm4zIvfBojeDWLVap1l5S/WpWf2mw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033