UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'g/JfbXdq91zHbX00BiztJnWv0LWjs4oDRi6pEzdEGQ4=' 
WHERE 
  key_id = '80c9b2c5698bc7e30a040e0f52d5acc55fea26eb31bb91a5877f84d7c9b9cacc' 
  AND (
    token = 'g/JfbXdq91zHbX00BiztJnWv0LWjs4oDRi6pEzdEGQ4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039