UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9KsPV44c2A158szmTgibjOTsL/Kla/QVZRoawdaQGMg=' 
WHERE 
  key_id = '8f24b37cf78f443a37c7ea0e4abac81e66631ad56c56aaab820a0ff246b7c91a' 
  AND (
    token = '9KsPV44c2A158szmTgibjOTsL/Kla/QVZRoawdaQGMg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029