UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tR0fHTjj10290wL1HIkzRsQ8Qc/7fSDnDhTSWP0l9qE=' 
WHERE 
  key_id = '50680827cc1ecad56ab0ad015b97581c605916a86b8cf4008c8bc5ccd1159747' 
  AND (
    token = 'tR0fHTjj10290wL1HIkzRsQ8Qc/7fSDnDhTSWP0l9qE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045