UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Y3EPWdh6IbnKJLhNI0HPDu4Am4/e79xoH4Mz7/gpAYA=' 
WHERE 
  key_id = '37d48a1bab5fd155c9797a2b87bf13b22376b124dd5706ea1758821004733269' 
  AND (
    token = 'Y3EPWdh6IbnKJLhNI0HPDu4Am4/e79xoH4Mz7/gpAYA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035