UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rnrUbtBRlQ0ojR6h7KEUR9Yd0A0KAHEr6DCo38xa8G8=' 
WHERE 
  key_id = 'c645db71437ee4a5ccbf9aeea43cef5f6a40a4a78f8b211abb2d31533ee59dc0' 
  AND (
    token = 'rnrUbtBRlQ0ojR6h7KEUR9Yd0A0KAHEr6DCo38xa8G8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039