UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'am4Un1HRzc2oXAi9pcwViJ5c8Zraq5cAM9QKAsOR7e4=' 
WHERE 
  key_id = 'd50b4f5353924fa9c7cd47025a3762e8755357df6d77781a92347edf74c4cf03' 
  AND (
    token = 'am4Un1HRzc2oXAi9pcwViJ5c8Zraq5cAM9QKAsOR7e4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032