UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FsXrEp7g0q2x7rOfCSoJPNE/z1Hjxk90fse5Zk3/i2s=' 
WHERE 
  key_id = '6059b0908e9e429c95a87d137128c2d28e7c785ba7176e41bb4274e8d2de4697' 
  AND (
    token = 'FsXrEp7g0q2x7rOfCSoJPNE/z1Hjxk90fse5Zk3/i2s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027